insert overwrite table transactions
SELECT * from transactions
where trim(station_id)!='D80004' and trim(station_id)!='80004';

insert overwrite table transaction_items_oil
SELECT * from transaction_items_oil
where trim(station_id)!='D80004' and trim(station_id)!='80004';

insert overwrite table transaction_items_notoil
SELECT * from transaction_items_notoil
where trim(station_id)!='D80004' and trim(station_id)!='80004';

insert overwrite table products
SELECT * from products
where trim(station_id)!='D80004' and trim(station_id)!='80004';

insert overwrite table departments
SELECT * from departments
where trim(station_id)!='D80004' and trim(station_id)!='80004';

insert overwrite table Grades
SELECT * from Grades
where trim(station_id)!='D80004' and trim(station_id)!='80004';

insert overwrite table future_grade_price
SELECT * from future_grade_price
where trim(station_id)!='D80004' and trim(station_id)!='80004';

insert overwrite table transaction_items_mop
SELECT * from transaction_items_mop
where trim(station_id)!='D80004' and trim(station_id)!='80004';

insert overwrite table cashiers
SELECT * from cashiers
where trim(station_id)!='D80004' and trim(station_id)!='80004';


insert overwrite table Hoses
SELECT * from Hoses
where trim(station_id)!='D80004' and trim(station_id)!='80004';

insert overwrite table Hose_Delivery
SELECT * from Hose_Delivery
where trim(station_id)!='D80004' and trim(station_id)!='80004';

insert overwrite table Pumps
SELECT * from Pumps
where trim(station_id)!='D80004' and trim(station_id)!='80004';


